﻿CREATE TABLE [dbo].[user_Restore] (
    [Email]           NVARCHAR (256) NOT NULL,
    [UserHashCode]    NVARCHAR (32)  NOT NULL,
    [RestoreHashCode] NVARCHAR (32)  NOT NULL,
    [CreateDate]      DATETIME       CONSTRAINT [DF_UserRestore_CreateDate] DEFAULT (getdate()) NOT NULL,
    CONSTRAINT [FK_user_Restore_user_User] FOREIGN KEY ([Email]) REFERENCES [dbo].[user_User] ([Email])
);


GO
CREATE CLUSTERED INDEX [IX_user_Restore_Email]
    ON [dbo].[user_Restore]([Email] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_Table_RestoreHashCode]
    ON [dbo].[user_Restore]([RestoreHashCode] ASC);

